Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 52413 |
| Missing cells | 115934 |
| Missing cells (%) | 13.8% |
| Duplicate rows | 1371 |
| Duplicate rows (%) | 2.6% |
| Total size in memory | 8.8 MiB |
| Average record size in memory | 176.3 B |
Variable types
| Numeric | 14 |
|---|---|
| Categorical | 2 |
14618_FERM0101.DO_2_PV has constant value "0.0" | Constant |
| Dataset has 1371 (2.6%) duplicate rows | Duplicates |
14618_FERM0101.PUMP_1_PV is highly imbalanced (> 99.9%) | Imbalance |
14618_FERM0101.Agitation_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.Air_Sparge_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.Biocontainer_Pressure_PV has 4317 (8.2%) missing values | Missing |
14618_FERM0101.DO_1_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.DO_2_PV has 51162 (97.6%) missing values | Missing |
14618_FERM0101.Gas_Overlay_PV has 4318 (8.2%) missing values | Missing |
14618_FERM0101.Load_Cell_Net_PV has 4317 (8.2%) missing values | Missing |
14618_FERM0101.pH_1_PV has 4317 (8.2%) missing values | Missing |
14618_FERM0101.pH_2_PV has 4317 (8.2%) missing values | Missing |
14618_FERM0101.PUMP_1_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.PUMP_1_TOTAL has 4317 (8.2%) missing values | Missing |
14618_FERM0101.PUMP_2_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.PUMP_2_TOTAL has 4318 (8.2%) missing values | Missing |
14618_FERM0101.Single_Use_DO_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.Single_Use_pH_PV has 4319 (8.2%) missing values | Missing |
14618_FERM0101.Temperatura_PV has 4318 (8.2%) missing values | Missing |
14618_FERM0101.PUMP_2_PV is highly skewed (γ1 = 113.0348869) | Skewed |
14618_FERM0101.Agitation_PV has 25737 (49.1%) zeros | Zeros |
14618_FERM0101.Air_Sparge_PV has 47007 (89.7%) zeros | Zeros |
14618_FERM0101.DO_1_PV has 43568 (83.1%) zeros | Zeros |
14618_FERM0101.Gas_Overlay_PV has 22256 (42.5%) zeros | Zeros |
14618_FERM0101.Load_Cell_Net_PV has 985 (1.9%) zeros | Zeros |
14618_FERM0101.PUMP_1_TOTAL has 7595 (14.5%) zeros | Zeros |
14618_FERM0101.PUMP_2_PV has 47837 (91.3%) zeros | Zeros |
14618_FERM0101.PUMP_2_TOTAL has 25441 (48.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-09-29 18:20:46.436741 |
|---|---|
| Analysis finished | 2024-09-29 18:21:01.021237 |
| Duration | 14.58 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
14618_FERM0101.Agitation_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 685 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.319701 |
| Minimum | 0 |
|---|---|
| Maximum | 80 |
| Zeros | 25737 |
| Zeros (%) | 49.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 44 |
| 95-th percentile | 72 |
| Maximum | 80 |
| Range | 80 |
| Interquartile range (IQR) | 44 |
Descriptive statistics
| Standard deviation | 27.653088 |
|---|---|
| Coefficient of variation (CV) | 1.2970674 |
| Kurtosis | -0.71846222 |
| Mean | 21.319701 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.93124719 |
| Sum | 1025349.7 |
| Variance | 764.6933 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 25737 | |
| 20 | 8131 | 15.5% |
| 72 | 7897 | 15.1% |
| 44 | 2734 | 5.2% |
| 56 | 285 | 0.5% |
| 40 | 191 | 0.4% |
| 48 | 162 | 0.3% |
| 69.75 | 146 | 0.3% |
| 69.71999512 | 131 | 0.2% |
| 38.46400146 | 129 | 0.2% |
| Other values (675) | 2551 | 4.9% |
| (Missing) | 4319 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 25737 | |
| 20 | 8131 | 15.5% |
| 20.08859372 | 1 | < 0.1% |
| 20.18091561 | 1 | < 0.1% |
| 20.36940037 | 1 | < 0.1% |
| 20.55766634 | 1 | < 0.1% |
| 20.61520405 | 1 | < 0.1% |
| 20.74596573 | 1 | < 0.1% |
| 20.93433997 | 1 | < 0.1% |
| 21.08880422 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 80 | 1 | < 0.1% |
| 72 | 7897 | |
| 71.99993896 | 1 | < 0.1% |
| 71.99987183 | 1 | < 0.1% |
| 71.99980751 | 1 | < 0.1% |
| 71.99974365 | 1 | < 0.1% |
| 71.99967938 | 1 | < 0.1% |
| 71.99961548 | 1 | < 0.1% |
| 71.99954834 | 1 | < 0.1% |
| 71.99948405 | 1 | < 0.1% |
14618_FERM0101.Air_Sparge_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 1088 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17821932 |
| Minimum | 0 |
|---|---|
| Maximum | 16.003441 |
| Zeros | 47007 |
| Zeros (%) | 89.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 16.003441 |
| Range | 16.003441 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.4626509 |
|---|---|
| Coefficient of variation (CV) | 8.2070279 |
| Kurtosis | 89.57233 |
| Mean | 0.17821932 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.2947051 |
| Sum | 8571.2797 |
| Variance | 2.1393476 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 47007 | |
| 3.6794262 | 1 | < 0.1% |
| 3.679850036 | 1 | < 0.1% |
| 3.680054243 | 1 | < 0.1% |
| 3.680160356 | 1 | < 0.1% |
| 3.679771421 | 1 | < 0.1% |
| 3.679596645 | 1 | < 0.1% |
| 3.67996508 | 1 | < 0.1% |
| 3.679643929 | 1 | < 0.1% |
| 3.679364987 | 1 | < 0.1% |
| Other values (1078) | 1078 | 2.1% |
| (Missing) | 4319 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 47007 | |
| 0.001175312616 | 1 | < 0.1% |
| 0.02134601408 | 1 | < 0.1% |
| 0.02238436258 | 1 | < 0.1% |
| 0.0448427214 | 1 | < 0.1% |
| 0.07605827248 | 1 | < 0.1% |
| 0.07701893377 | 1 | < 0.1% |
| 0.07844730439 | 1 | < 0.1% |
| 0.08003383286 | 1 | < 0.1% |
| 0.08020449798 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 16.00344099 | 1 | |
| 16.0028945 | 1 | |
| 16.0026284 | 1 | |
| 16.00194744 | 1 | |
| 16.00186885 | 1 | |
| 16.00161009 | 1 | |
| 16.00151308 | 1 | |
| 16.00149385 | 1 | |
| 16.00140251 | 1 | |
| 16.001383 | 1 |
14618_FERM0101.Biocontainer_Pressure_PV
Real number (ℝ)
MISSING
| Distinct | 20406 |
|---|---|
| Distinct (%) | 42.4% |
| Missing | 4317 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 180.59735 |
| Minimum | -6.8200256 |
|---|---|
| Maximum | 480 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 20073 |
| Negative (%) | 38.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -6.8200256 |
|---|---|
| 5-th percentile | -1.9292566 |
| Q1 | -0.8246521 |
| median | 1.4035326 |
| Q3 | 480 |
| 95-th percentile | 480 |
| Maximum | 480 |
| Range | 486.82003 |
| Interquartile range (IQR) | 480.82465 |
Descriptive statistics
| Standard deviation | 232.65288 |
|---|---|
| Coefficient of variation (CV) | 1.2882408 |
| Kurtosis | -1.7400277 |
| Mean | 180.59735 |
| Median Absolute Deviation (MAD) | 2.834654 |
| Skewness | 0.50983058 |
| Sum | 8686010.3 |
| Variance | 54127.361 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 480 | 18107 | |
| -0.7841430664 | 211 | 0.4% |
| -1.270257568 | 208 | 0.4% |
| -1.027197266 | 202 | 0.4% |
| -0.8246520996 | 198 | 0.4% |
| -1.25 | 190 | 0.4% |
| -0.358795166 | 179 | 0.3% |
| -0.3385437012 | 172 | 0.3% |
| -1.067706299 | 157 | 0.3% |
| -0.7638916016 | 157 | 0.3% |
| Other values (20396) | 28315 | |
| (Missing) | 4317 | 8.2% |
| Value | Count | Frequency (%) |
| -6.820025635 | 1 | |
| -5.553515655 | 1 | |
| -4.358417209 | 1 | |
| -4.358299059 | 1 | |
| -4.348956299 | 1 | |
| -4.325953272 | 1 | |
| -4.316362015 | 1 | |
| -4.315764755 | 1 | |
| -4.308447266 | 1 | |
| -4.298823655 | 1 |
| Value | Count | Frequency (%) |
| 480 | 18107 | |
| 8.858420452 | 1 | < 0.1% |
| 8.370230801 | 1 | < 0.1% |
| 8.001777869 | 1 | < 0.1% |
| 7.961963132 | 1 | < 0.1% |
| 7.935359641 | 1 | < 0.1% |
| 7.262870687 | 1 | < 0.1% |
| 7.238857972 | 1 | < 0.1% |
| 7.06877937 | 1 | < 0.1% |
| 6.82586372 | 1 | < 0.1% |
14618_FERM0101.DO_1_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 3352 |
|---|---|
| Distinct (%) | 7.0% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.7690941 |
| Minimum | 0 |
|---|---|
| Maximum | 102.02023 |
| Zeros | 43568 |
| Zeros (%) | 83.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 18.402357 |
| Maximum | 102.02023 |
| Range | 102.02023 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 10.635949 |
|---|---|
| Coefficient of variation (CV) | 3.840949 |
| Kurtosis | 26.384366 |
| Mean | 2.7690941 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.9160019 |
| Sum | 133176.81 |
| Variance | 113.12341 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 43568 | |
| 16.01008301 | 28 | 0.1% |
| 16.15122986 | 26 | < 0.1% |
| 16.28733521 | 23 | < 0.1% |
| 15.73282928 | 15 | < 0.1% |
| 15.84533691 | 12 | < 0.1% |
| 15.5926651 | 9 | < 0.1% |
| 15.17424011 | 8 | < 0.1% |
| 16.14216461 | 8 | < 0.1% |
| 16.38938141 | 8 | < 0.1% |
| Other values (3342) | 4389 | 8.4% |
| (Missing) | 4319 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 43568 | |
| 0.02002252489 | 3 | < 0.1% |
| 0.02044859082 | 1 | < 0.1% |
| 0.2953322411 | 4 | < 0.1% |
| 0.5756475925 | 4 | < 0.1% |
| 0.8509572983 | 4 | < 0.1% |
| 1.121261406 | 2 | < 0.1% |
| 1.125600793 | 1 | < 0.1% |
| 1.126266956 | 3 | < 0.1% |
| 1.26141901 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 102.0202271 | 1 | |
| 92.85025024 | 1 | |
| 92.67866821 | 1 | |
| 91.99846802 | 1 | |
| 91.96911011 | 1 | |
| 90.54976807 | 1 | |
| 90.20249023 | 1 | |
| 89.45551251 | 1 | |
| 88.00853271 | 1 | |
| 88.00588916 | 1 |
14618_FERM0101.DO_2_PV
Categorical
CONSTANT MISSING
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 51162 |
| Missing (%) | 97.6% |
| Memory size | 2.8 MiB |
| 0.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3753 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 1251 | 2.4% |
| (Missing) | 51162 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 1251 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2502 | |
| . | 1251 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3753 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2502 | |
| . | 1251 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3753 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2502 | |
| . | 1251 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3753 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 2502 | |
| . | 1251 |
14618_FERM0101.Gas_Overlay_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 25840 |
|---|---|
| Distinct (%) | 53.7% |
| Missing | 4318 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1767573 |
| Minimum | 0 |
|---|---|
| Maximum | 16.104419 |
| Zeros | 22256 |
| Zeros (%) | 42.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3.9996518 |
| Q3 | 4.000023 |
| 95-th percentile | 4.000317 |
| Maximum | 16.104419 |
| Range | 16.104419 |
| Interquartile range (IQR) | 4.000023 |
Descriptive statistics
| Standard deviation | 2.0990125 |
|---|---|
| Coefficient of variation (CV) | 0.96428413 |
| Kurtosis | 1.943548 |
| Mean | 2.1767573 |
| Median Absolute Deviation (MAD) | 0.0007119272 |
| Skewness | 0.46918134 |
| Sum | 104691.14 |
| Variance | 4.4058536 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 22256 | |
| 4.000057112 | 1 | < 0.1% |
| 4.000367396 | 1 | < 0.1% |
| 4.000241637 | 1 | < 0.1% |
| 3.999813923 | 1 | < 0.1% |
| 3.99977573 | 1 | < 0.1% |
| 4.000331056 | 1 | < 0.1% |
| 4.000628803 | 1 | < 0.1% |
| 4.000115933 | 1 | < 0.1% |
| 3.999896725 | 1 | < 0.1% |
| Other values (25830) | 25830 | |
| (Missing) | 4318 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 22256 | |
| 0.9544483463 | 1 | < 0.1% |
| 2.39974252 | 1 | < 0.1% |
| 2.399779091 | 1 | < 0.1% |
| 2.399879811 | 1 | < 0.1% |
| 2.399909345 | 1 | < 0.1% |
| 2.39993115 | 1 | < 0.1% |
| 2.399958561 | 1 | < 0.1% |
| 2.400025709 | 1 | < 0.1% |
| 2.400041975 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 16.10441948 | 1 | |
| 16.03274971 | 1 | |
| 16.02965684 | 1 | |
| 16.01333154 | 1 | |
| 16.00741039 | 1 | |
| 16.00628667 | 1 | |
| 16.00532541 | 1 | |
| 16.00509485 | 1 | |
| 16.00416077 | 1 | |
| 16.00390381 | 1 |
14618_FERM0101.Load_Cell_Net_PV
Real number (ℝ)
MISSING ZEROS
| Distinct | 2263 |
|---|---|
| Distinct (%) | 4.7% |
| Missing | 4317 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 63.01686 |
| Minimum | -9.0400002 |
|---|---|
| Maximum | 182.56 |
| Zeros | 985 |
| Zeros (%) | 1.9% |
| Negative | 19324 |
| Negative (%) | 36.9% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -9.0400002 |
|---|---|
| 5-th percentile | -6.9600006 |
| Q1 | -6.2400002 |
| median | 5.9200001 |
| Q3 | 159.12 |
| 95-th percentile | 167.76102 |
| Maximum | 182.56 |
| Range | 191.6 |
| Interquartile range (IQR) | 165.36 |
Descriptive statistics
| Standard deviation | 74.35043 |
|---|---|
| Coefficient of variation (CV) | 1.1798498 |
| Kurtosis | -1.6475377 |
| Mean | 63.01686 |
| Median Absolute Deviation (MAD) | 13.04 |
| Skewness | 0.37271496 |
| Sum | 3030858.9 |
| Variance | 5527.9865 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -6.8 | 2868 | 5.5% |
| -6.719999695 | 1925 | 3.7% |
| -6.880000305 | 1672 | 3.2% |
| -6.640000153 | 1375 | 2.6% |
| -5.840000153 | 1060 | 2.0% |
| -7.119999695 | 997 | 1.9% |
| 0 | 985 | 1.9% |
| 0.07999992371 | 971 | 1.9% |
| -5.920000076 | 808 | 1.5% |
| -6.240000153 | 751 | 1.4% |
| Other values (2253) | 34684 | |
| (Missing) | 4317 | 8.2% |
| Value | Count | Frequency (%) |
| -9.040000153 | 19 | < 0.1% |
| -7.519999695 | 3 | < 0.1% |
| -7.43999939 | 290 | |
| -7.42341168 | 1 | < 0.1% |
| -7.422402028 | 1 | < 0.1% |
| -7.421834435 | 1 | < 0.1% |
| -7.377805421 | 1 | < 0.1% |
| -7.377762292 | 1 | < 0.1% |
| -7.376931486 | 1 | < 0.1% |
| -7.376804696 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 182.5599976 | 1 | |
| 181.3599976 | 1 | |
| 180.9888049 | 1 | |
| 179.6800049 | 1 | |
| 179.5377841 | 1 | |
| 179.0773461 | 1 | |
| 178.5305097 | 1 | |
| 178.004149 | 1 | |
| 177.2018284 | 1 | |
| 176.6400024 | 1 |
14618_FERM0101.pH_1_PV
Real number (ℝ)
MISSING
| Distinct | 2477 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 4317 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -31.45005 |
| Minimum | -527.38716 |
|---|---|
| Maximum | 9.5703156 |
| Zeros | 55 |
| Zeros (%) | 0.1% |
| Negative | 3326 |
| Negative (%) | 6.3% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -527.38716 |
|---|---|
| 5-th percentile | -527.38716 |
| Q1 | 4.5398506 |
| median | 6.2720001 |
| Q3 | 6.2720001 |
| 95-th percentile | 6.2985077 |
| Maximum | 9.5703156 |
| Range | 536.95747 |
| Interquartile range (IQR) | 1.7321495 |
Descriptive statistics
| Standard deviation | 135.05524 |
|---|---|
| Coefficient of variation (CV) | -4.2942774 |
| Kurtosis | 9.5573648 |
| Mean | -31.45005 |
| Median Absolute Deviation (MAD) | 0.0066684723 |
| Skewness | -3.3991831 |
| Sum | -1512621.6 |
| Variance | 18239.918 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6.272000122 | 23841 | |
| 4.539850616 | 4451 | 8.5% |
| -527.3871582 | 3315 | 6.3% |
| 6.368000031 | 1433 | 2.7% |
| 1.547423744 | 1298 | 2.5% |
| 6.240000153 | 1164 | 2.2% |
| 1.870640564 | 799 | 1.5% |
| 1.248973465 | 725 | 1.4% |
| 1.921421623 | 663 | 1.3% |
| 1.725261307 | 534 | 1.0% |
| Other values (2467) | 9873 | |
| (Missing) | 4317 | 8.2% |
| Value | Count | Frequency (%) |
| -527.3871582 | 3315 | |
| -526.3940933 | 1 | < 0.1% |
| -526.1155903 | 1 | < 0.1% |
| -525.0820986 | 1 | < 0.1% |
| -516.1368823 | 1 | < 0.1% |
| -515.2058735 | 1 | < 0.1% |
| -191.6294922 | 1 | < 0.1% |
| -8.040552655 | 1 | < 0.1% |
| -6.776113243 | 1 | < 0.1% |
| -5.625047633 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.570315552 | 1 | |
| 9.564295103 | 1 | |
| 9.553175354 | 1 | |
| 9.552114868 | 1 | |
| 9.52927475 | 1 | |
| 8.959867859 | 1 | |
| 8.941677173 | 1 | |
| 8.706869507 | 1 | |
| 8.659645779 | 1 | |
| 8.614128113 | 1 |
14618_FERM0101.pH_2_PV
Real number (ℝ)
MISSING
| Distinct | 4443 |
|---|---|
| Distinct (%) | 9.2% |
| Missing | 4317 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5007568 |
| Minimum | -0.34243126 |
|---|---|
| Maximum | 10.347078 |
| Zeros | 18 |
| Zeros (%) | < 0.1% |
| Negative | 1501 |
| Negative (%) | 2.9% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.34243126 |
|---|---|
| 5-th percentile | 0.59812069 |
| Q1 | 0.59812069 |
| median | 1.4241299 |
| Q3 | 5.734057 |
| 95-th percentile | 6.2683555 |
| Maximum | 10.347078 |
| Range | 10.689509 |
| Interquartile range (IQR) | 5.1359363 |
Descriptive statistics
| Standard deviation | 2.3141617 |
|---|---|
| Coefficient of variation (CV) | 0.92538457 |
| Kurtosis | -1.0091043 |
| Mean | 2.5007568 |
| Median Absolute Deviation (MAD) | 0.82600918 |
| Skewness | 0.84111392 |
| Sum | 120276.4 |
| Variance | 5.3553446 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.5981206894 | 12295 | |
| 1.311432457 | 3268 | 6.2% |
| 1.410075378 | 1894 | 3.6% |
| 1.713100052 | 1608 | 3.1% |
| 1.469761086 | 1531 | 2.9% |
| 0.8277111053 | 1426 | 2.7% |
| -0.3424312592 | 1399 | 2.7% |
| 1.346100426 | 1097 | 2.1% |
| 1.442509651 | 897 | 1.7% |
| 1.268571854 | 754 | 1.4% |
| Other values (4433) | 21927 | |
| (Missing) | 4317 | 8.2% |
| Value | Count | Frequency (%) |
| -0.3424312592 | 1399 | |
| -0.09845277007 | 1 | < 0.1% |
| -0.09799090862 | 1 | < 0.1% |
| -0.06752948761 | 100 | 0.2% |
| 0 | 18 | < 0.1% |
| 0.001008301827 | 1 | < 0.1% |
| 0.002889567541 | 1 | < 0.1% |
| 0.004881653754 | 1 | < 0.1% |
| 0.2439928552 | 1 | < 0.1% |
| 0.2686611904 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10.34707794 | 27 | |
| 10.33210297 | 1 | < 0.1% |
| 10.26894531 | 1 | < 0.1% |
| 10.19732208 | 1 | < 0.1% |
| 10.13416443 | 1 | < 0.1% |
| 10.06221619 | 1 | < 0.1% |
| 9.998046989 | 1 | < 0.1% |
| 9.918283655 | 1 | < 0.1% |
| 9.846372986 | 1 | < 0.1% |
| 9.783215332 | 1 | < 0.1% |
14618_FERM0101.PUMP_1_PV
Categorical
IMBALANCE MISSING
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Memory size | 2.8 MiB |
| 0.0 | |
|---|---|
| 48.0 | 1 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0000208 |
| Min length | 3 |
Characters and Unicode
| Total characters | 144283 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 48093 | |
| 48.0 | 1 | < 0.1% |
| (Missing) | 4319 | 8.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 48093 | |
| 48.0 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 96187 | |
| . | 48094 | |
| 4 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 144283 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96187 | |
| . | 48094 | |
| 4 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 144283 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96187 | |
| . | 48094 | |
| 4 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 144283 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 96187 | |
| . | 48094 | |
| 4 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
14618_FERM0101.PUMP_1_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 124 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 4317 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.441754 |
| Minimum | 0 |
|---|---|
| Maximum | 277.7603 |
| Zeros | 7595 |
| Zeros (%) | 14.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 7.4399994 |
| median | 12.4 |
| Q3 | 19.840001 |
| 95-th percentile | 34.719998 |
| Maximum | 277.7603 |
| Range | 277.7603 |
| Interquartile range (IQR) | 12.400002 |
Descriptive statistics
| Standard deviation | 27.211317 |
|---|---|
| Coefficient of variation (CV) | 1.4755276 |
| Kurtosis | 13.09944 |
| Mean | 18.441754 |
| Median Absolute Deviation (MAD) | 7.4400002 |
| Skewness | 3.6113309 |
| Sum | 886974.59 |
| Variance | 740.45579 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 7595 | |
| 9.919999695 | 6517 | |
| 7.43999939 | 5124 | |
| 24.80000153 | 5098 | |
| 14.88000031 | 4727 | |
| 12.4 | 3723 | |
| 4.959999847 | 2934 | 5.6% |
| 19.84000092 | 2892 | 5.5% |
| 17.36000061 | 2740 | 5.2% |
| 138.8800415 | 1866 | 3.6% |
| Other values (114) | 4880 | |
| (Missing) | 4317 |
| Value | Count | Frequency (%) |
| 0 | 7595 | |
| 0.00974709501 | 1 | < 0.1% |
| 0.03703816176 | 1 | < 0.1% |
| 0.05264017242 | 1 | < 0.1% |
| 0.05308667913 | 1 | < 0.1% |
| 0.1663549549 | 1 | < 0.1% |
| 0.1776579516 | 1 | < 0.1% |
| 0.2694939981 | 1 | < 0.1% |
| 0.4853862864 | 1 | < 0.1% |
| 0.6648702185 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 277.7603027 | 1 | < 0.1% |
| 138.8800415 | 1866 | |
| 133.9200317 | 53 | 0.1% |
| 116.5599976 | 44 | 0.1% |
| 108.7680082 | 1 | < 0.1% |
| 104.1599731 | 132 | 0.3% |
| 101.6799683 | 1 | < 0.1% |
| 96.7199707 | 85 | 0.2% |
| 86.79997559 | 78 | 0.1% |
| 81.83997803 | 2 | < 0.1% |
14618_FERM0101.PUMP_2_PV
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 252 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.014244512 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 47837 |
| Zeros (%) | 91.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4497774 |
|---|---|
| Coefficient of variation (CV) | 31.575487 |
| Kurtosis | 16368.253 |
| Mean | 0.014244512 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 113.03489 |
| Sum | 685.07555 |
| Variance | 0.20229971 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 47837 | |
| 8 | 3 | < 0.1% |
| 0.3999938965 | 3 | < 0.1% |
| 0.799987793 | 2 | < 0.1% |
| 1.599975586 | 2 | < 0.1% |
| 3.52133918 | 1 | < 0.1% |
| 5.337225248 | 1 | < 0.1% |
| 2.799957275 | 1 | < 0.1% |
| 6.919450427 | 1 | < 0.1% |
| 5.599914551 | 1 | < 0.1% |
| Other values (242) | 242 | 0.5% |
| (Missing) | 4319 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 47837 | |
| 8.153406573 × 10-5 | 1 | < 0.1% |
| 0.0003766481819 | 1 | < 0.1% |
| 0.0003819443561 | 1 | < 0.1% |
| 0.0003871383672 | 1 | < 0.1% |
| 0.0004031073601 | 1 | < 0.1% |
| 0.0004059485857 | 1 | < 0.1% |
| 0.0004249513297 | 1 | < 0.1% |
| 0.0004291392644 | 1 | < 0.1% |
| 0.0004307850753 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | < 0.1% |
| 48 | 1 | < 0.1% |
| 8 | 3 | |
| 7.901955109 | 1 | < 0.1% |
| 7.775875092 | 1 | < 0.1% |
| 7.759765421 | 1 | < 0.1% |
| 7.479987335 | 1 | < 0.1% |
| 6.919450427 | 1 | < 0.1% |
| 6.662841346 | 1 | < 0.1% |
| 6.657589845 | 1 | < 0.1% |
14618_FERM0101.PUMP_2_TOTAL
Real number (ℝ)
MISSING ZEROS
| Distinct | 308 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 4318 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.468309 |
| Minimum | 0 |
|---|---|
| Maximum | 887.69902 |
| Zeros | 25441 |
| Zeros (%) | 48.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 21.484485 |
| 95-th percentile | 80.432556 |
| Maximum | 887.69902 |
| Range | 887.69902 |
| Interquartile range (IQR) | 21.484485 |
Descriptive statistics
| Standard deviation | 88.202283 |
|---|---|
| Coefficient of variation (CV) | 3.2110562 |
| Kurtosis | 48.280865 |
| Mean | 27.468309 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.5866635 |
| Sum | 1321088.3 |
| Variance | 7779.6428 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 25441 | |
| 11.8683548 | 3770 | 7.2% |
| 62.8109314 | 3386 | 6.5% |
| 18.15523224 | 1624 | 3.1% |
| 27.21213379 | 1440 | 2.7% |
| 6.999950409 | 912 | 1.7% |
| 15.8484024 | 892 | 1.7% |
| 29.77175903 | 792 | 1.5% |
| 54.69425049 | 775 | 1.5% |
| 5.658672714 | 765 | 1.5% |
| Other values (298) | 8298 | 15.8% |
| (Missing) | 4318 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 25441 | |
| 0.1650124246 | 1 | < 0.1% |
| 0.7794020176 | 1 | < 0.1% |
| 0.9340991974 | 40 | 0.1% |
| 0.9354771614 | 7 | < 0.1% |
| 0.938307476 | 6 | < 0.1% |
| 1.082270622 | 130 | 0.2% |
| 1.319999981 | 89 | 0.2% |
| 1.336016557 | 1 | < 0.1% |
| 1.367676144 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 887.6990234 | 130 | 0.2% |
| 625.8225586 | 587 | |
| 613.694043 | 1 | < 0.1% |
| 609.7284668 | 1 | < 0.1% |
| 595.3473633 | 1 | < 0.1% |
| 584.563623 | 1 | < 0.1% |
| 579.7435059 | 1 | < 0.1% |
| 567.3348633 | 1 | < 0.1% |
| 561.5749512 | 1 | < 0.1% |
| 552.5736816 | 1 | < 0.1% |
14618_FERM0101.Single_Use_DO_PV
Real number (ℝ)
MISSING
| Distinct | 5043 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 707.84403 |
| Minimum | 0 |
|---|---|
| Maximum | 943.94336 |
| Zeros | 17 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 19.009894 |
| Q1 | 735.89551 |
| median | 799.99199 |
| Q3 | 799.99199 |
| 95-th percentile | 861.68896 |
| Maximum | 943.94336 |
| Range | 943.94336 |
| Interquartile range (IQR) | 64.096484 |
Descriptive statistics
| Standard deviation | 239.38477 |
|---|---|
| Coefficient of variation (CV) | 0.33818858 |
| Kurtosis | 3.9586903 |
| Mean | 707.84403 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.3555859 |
| Sum | 34043051 |
| Variance | 57305.069 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 799.9919922 | 26288 | |
| 861.6889648 | 3318 | 6.3% |
| 753.5009766 | 1753 | 3.3% |
| 703.7227051 | 1557 | 3.0% |
| 711.8633301 | 1437 | 2.7% |
| 770.7051758 | 899 | 1.7% |
| 943.9433594 | 777 | 1.5% |
| 735.8955078 | 740 | 1.4% |
| 701.4396973 | 704 | 1.3% |
| 672.9973633 | 703 | 1.3% |
| Other values (5033) | 9918 | 18.9% |
| (Missing) | 4319 | 8.2% |
| Value | Count | Frequency (%) |
| 0 | 17 | |
| 0.175999999 | 1 | < 0.1% |
| 0.1785494304 | 1 | < 0.1% |
| 0.1795871002 | 1 | < 0.1% |
| 0.185721571 | 1 | < 0.1% |
| 0.185729005 | 1 | < 0.1% |
| 0.1874370318 | 1 | < 0.1% |
| 0.1919999957 | 1 | < 0.1% |
| 0.1936220553 | 1 | < 0.1% |
| 0.193647009 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 943.9433594 | 777 | 1.5% |
| 916.6861328 | 668 | 1.3% |
| 880.4666016 | 21 | < 0.1% |
| 861.6889648 | 3318 | 6.3% |
| 856.2474609 | 46 | 0.1% |
| 813.320528 | 1 | < 0.1% |
| 812.7334602 | 1 | < 0.1% |
| 809.7904297 | 400 | 0.8% |
| 800.6487981 | 1 | < 0.1% |
| 799.9919922 | 26288 |
14618_FERM0101.Single_Use_pH_PV
Real number (ℝ)
MISSING
| Distinct | 1155 |
|---|---|
| Distinct (%) | 2.4% |
| Missing | 4319 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 708.24391 |
| Minimum | 0.095999908 |
|---|---|
| Maximum | 801.93599 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | 0.095999908 |
|---|---|
| 5-th percentile | 5.9599998 |
| Q1 | 799.96001 |
| median | 800.13599 |
| Q3 | 800.304 |
| 95-th percentile | 800.6 |
| Maximum | 801.93599 |
| Range | 801.83999 |
| Interquartile range (IQR) | 0.34399414 |
Descriptive statistics
| Standard deviation | 254.14481 |
|---|---|
| Coefficient of variation (CV) | 0.35883797 |
| Kurtosis | 3.7679337 |
| Mean | 708.24391 |
| Median Absolute Deviation (MAD) | 0.16801758 |
| Skewness | -2.4014909 |
| Sum | 34062283 |
| Variance | 64589.583 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 800.3040039 | 6179 | 11.8% |
| 799.9600098 | 5179 | 9.9% |
| 800.2799805 | 2325 | 4.4% |
| 799.9919922 | 2195 | 4.2% |
| 800.0080078 | 2128 | 4.1% |
| 800.4319824 | 2069 | 3.9% |
| 800.0799805 | 1919 | 3.7% |
| 800.1199707 | 1896 | 3.6% |
| 800.5759766 | 1616 | 3.1% |
| 800.6959961 | 1610 | 3.1% |
| Other values (1145) | 20978 | |
| (Missing) | 4319 | 8.2% |
| Value | Count | Frequency (%) |
| 0.09599990845 | 1 | < 0.1% |
| 0.3120002747 | 36 | |
| 3.06400032 | 1 | < 0.1% |
| 3.71274225 | 1 | < 0.1% |
| 4.244668042 | 1 | < 0.1% |
| 4.246134628 | 1 | < 0.1% |
| 4.246606346 | 1 | < 0.1% |
| 4.257382603 | 1 | < 0.1% |
| 4.257386492 | 1 | < 0.1% |
| 4.257560147 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 801.9359863 | 551 | 1.1% |
| 800.6959961 | 1610 | |
| 800.6 | 466 | 0.9% |
| 800.5759766 | 1616 | |
| 800.5120117 | 1337 | |
| 800.447998 | 477 | 0.9% |
| 800.4319824 | 2069 | |
| 800.352002 | 569 | 1.1% |
| 800.3359863 | 470 | 0.9% |
| 800.3279785 | 476 | 0.9% |
14618_FERM0101.Temperatura_PV
Real number (ℝ)
MISSING
| Distinct | 31607 |
|---|---|
| Distinct (%) | 65.7% |
| Missing | 4318 |
| Missing (%) | 8.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.607862 |
| Minimum | -0.24799805 |
|---|---|
| Maximum | 80.968005 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 2.8 MiB |
Quantile statistics
| Minimum | -0.24799805 |
|---|---|
| 5-th percentile | 3.223999 |
| Q1 | 13.656006 |
| median | 16.72304 |
| Q3 | 19.845951 |
| 95-th percentile | 29.55939 |
| Maximum | 80.968005 |
| Range | 81.216003 |
| Interquartile range (IQR) | 6.189945 |
Descriptive statistics
| Standard deviation | 8.1511146 |
|---|---|
| Coefficient of variation (CV) | 0.49079854 |
| Kurtosis | -0.59839087 |
| Mean | 16.607862 |
| Median Absolute Deviation (MAD) | 3.1057248 |
| Skewness | -0.076160193 |
| Sum | 798755.14 |
| Variance | 66.440669 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.208001709 | 540 | 1.0% |
| 3.2 | 431 | 0.8% |
| 3.247998047 | 388 | 0.7% |
| 3.232000732 | 344 | 0.7% |
| 3.255999756 | 212 | 0.4% |
| 3.191998291 | 133 | 0.3% |
| 3.223999023 | 130 | 0.2% |
| 29.71199951 | 103 | 0.2% |
| 29.71999512 | 98 | 0.2% |
| 3.279998779 | 98 | 0.2% |
| Other values (31597) | 45618 | |
| (Missing) | 4318 | 8.2% |
| Value | Count | Frequency (%) |
| -0.2479980469 | 1 | |
| 3.160515912 | 1 | |
| 3.167999268 | 2 | |
| 3.168187587 | 1 | |
| 3.16821143 | 1 | |
| 3.171719634 | 1 | |
| 3.1722099 | 1 | |
| 3.175977906 | 1 | |
| 3.176000977 | 2 | |
| 3.176174241 | 1 |
| Value | Count | Frequency (%) |
| 80.96800537 | 1 | |
| 30.22399902 | 1 | |
| 30.19081118 | 1 | |
| 30.14399414 | 1 | |
| 30.00799561 | 1 | |
| 29.98349416 | 1 | |
| 29.95298909 | 1 | |
| 29.94470398 | 1 | |
| 29.92430854 | 1 | |
| 29.85929605 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| 14618_FERM0101.Agitation_PV | 14618_FERM0101.Air_Sparge_PV | 14618_FERM0101.Biocontainer_Pressure_PV | 14618_FERM0101.DO_1_PV | 14618_FERM0101.DO_2_PV | 14618_FERM0101.Gas_Overlay_PV | 14618_FERM0101.Load_Cell_Net_PV | 14618_FERM0101.pH_1_PV | 14618_FERM0101.pH_2_PV | 14618_FERM0101.PUMP_1_PV | 14618_FERM0101.PUMP_1_TOTAL | 14618_FERM0101.PUMP_2_PV | 14618_FERM0101.PUMP_2_TOTAL | 14618_FERM0101.Single_Use_DO_PV | 14618_FERM0101.Single_Use_pH_PV | 14618_FERM0101.Temperatura_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2023-03-15 00:00:00.000 | 72.0 | 0.0 | 1.869612 | 15.953993 | NaN | 4.000057 | 169.600000 | -527.387158 | 5.998478 | 0.0 | 104.159973 | 0.0 | 0.0 | 16.713527 | 6.016000 | 29.456006 |
| 2023-03-15 00:15:00.000 | 72.0 | 0.0 | 1.950260 | 19.056868 | NaN | 3.999801 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 20.147099 | 6.016000 | 29.320005 |
| 2023-03-15 00:30:00.000 | 72.0 | 0.0 | 1.666673 | 22.584024 | NaN | 4.000541 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 24.099058 | 6.016000 | 29.720002 |
| 2023-03-15 00:45:00.000 | 72.0 | 0.0 | 1.686865 | 13.837698 | NaN | 3.999813 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 14.218414 | 6.015978 | 29.272062 |
| 2023-03-15 01:00:00.000 | 72.0 | 0.0 | 1.706948 | 16.378275 | NaN | 3.999787 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 17.115724 | 6.016000 | 29.472092 |
| 2023-03-15 01:15:00.000 | 72.0 | 0.0 | 1.910138 | 18.632587 | NaN | 3.999956 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 19.849174 | 6.016000 | 29.591338 |
| 2023-03-15 01:30:00.000 | 72.0 | 0.0 | 1.910098 | 21.592331 | NaN | 3.999718 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 22.761380 | 6.016000 | 29.295996 |
| 2023-03-15 01:45:00.000 | 72.0 | 0.0 | 2.275408 | 22.299596 | NaN | 3.999149 | 169.520007 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 25.640861 | 6.016000 | 29.671997 |
| 2023-03-15 02:00:00.000 | 72.0 | 0.0 | 1.829889 | 13.979342 | NaN | 4.000402 | 169.600000 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 14.292896 | 6.008000 | 29.343825 |
| 2023-03-15 02:15:00.000 | 72.0 | 0.0 | 1.869214 | 16.659424 | NaN | 4.000057 | 169.520007 | -527.387158 | 6.006379 | 0.0 | 104.159973 | 0.0 | 0.0 | 17.443440 | 6.016000 | 29.528170 |
| 14618_FERM0101.Agitation_PV | 14618_FERM0101.Air_Sparge_PV | 14618_FERM0101.Biocontainer_Pressure_PV | 14618_FERM0101.DO_1_PV | 14618_FERM0101.DO_2_PV | 14618_FERM0101.Gas_Overlay_PV | 14618_FERM0101.Load_Cell_Net_PV | 14618_FERM0101.pH_1_PV | 14618_FERM0101.pH_2_PV | 14618_FERM0101.PUMP_1_PV | 14618_FERM0101.PUMP_1_TOTAL | 14618_FERM0101.PUMP_2_PV | 14618_FERM0101.PUMP_2_TOTAL | 14618_FERM0101.Single_Use_DO_PV | 14618_FERM0101.Single_Use_pH_PV | 14618_FERM0101.Temperatura_PV | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DateTime | ||||||||||||||||
| 2024-09-10 21:45:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.370399 |
| 2024-09-10 22:00:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.272946 |
| 2024-09-10 22:15:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | 0.0 | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.394324 |
| 2024-09-10 22:30:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.275258 |
| 2024-09-10 22:45:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.231995 |
| 2024-09-10 23:00:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.353003 |
| 2024-09-10 23:15:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.251117 |
| 2024-09-10 23:30:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.239383 |
| 2024-09-10 23:45:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.224738 |
| 2024-09-11 00:00:00.000 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.24 | 1.248973 | -0.342431 | 0.0 | 29.760001 | 0.0 | 0.0 | 735.895508 | 800.03999 | 15.213614 |
Most frequently occurring
| 14618_FERM0101.Agitation_PV | 14618_FERM0101.Air_Sparge_PV | 14618_FERM0101.Biocontainer_Pressure_PV | 14618_FERM0101.DO_1_PV | 14618_FERM0101.DO_2_PV | 14618_FERM0101.Gas_Overlay_PV | 14618_FERM0101.Load_Cell_Net_PV | 14618_FERM0101.pH_1_PV | 14618_FERM0101.pH_2_PV | 14618_FERM0101.PUMP_1_PV | 14618_FERM0101.PUMP_1_TOTAL | 14618_FERM0101.PUMP_2_PV | 14618_FERM0101.PUMP_2_TOTAL | 14618_FERM0101.Single_Use_DO_PV | 14618_FERM0101.Single_Use_pH_PV | 14618_FERM0101.Temperatura_PV | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1370 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 4317 |
| 585 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.80 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.200000 | 17 |
| 586 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.80 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.216003 | 15 |
| 278 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.783997 | 13 |
| 287 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.928003 | 13 |
| 288 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.943994 | 13 |
| 311 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 27.312000 | 13 |
| 315 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 27.368005 | 13 |
| 267 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.607996 | 12 |
| 270 | 0.0 | 0.0 | 480.0 | 0.0 | NaN | 0.0 | -6.88 | 6.272 | 1.311432 | 0.0 | 24.800002 | 0.0 | 62.810931 | 861.688965 | 800.304004 | 26.656006 | 12 |